package edu.app.routines;

import edu.app.technique.ConnectionFactory;
import edu.app.helpers.ScriptHelper;
import java.sql.Connection;

public class Populate {
    
    public static void main(String[] args) {
        Connection connection = ConnectionFactory.getInstance().getConnection();
        String departmentsScript = ScriptHelper.getInstance().getScriptAsString("./scripts/populate_t_department.sql");
        String employeesScript = ScriptHelper.getInstance().getScriptAsString("./scripts/populate_t_employee.sql");
        ScriptHelper.getInstance().executeScript(departmentsScript, connection);
        ScriptHelper.getInstance().executeScript(employeesScript, connection);
    }

}
